
<!DOCTYPE html
  PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
   <title>ZeosDBO Change Notes</title><link rel="stylesheet" href="ede.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.66.0"></head><body><div xmlns="" id="customheader"><a href="http://zeos.firmos.at/portal.php" style="color: #fff; font-weight: bold;">ZeosLib</a><b> - open source tools for your database solutions</b></div><div class="article" lang="en"><div class="titlepage"><div><div><h1 class="title"><a id="d4e1"></a>ZeosDBO Change Notes</h1></div><div><h3 class="corpauthor">ZeosLib Development Group</h3></div></div><hr></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="sect1"><a href="#d4e5">1. Changes in Release 6.6.6 - stable (30.12.2009)</a></span></dt><dt><span class="sect1"><a href="#d4e66">2. Changes in Release 6.6.5 - stable (25.05.2009)</a></span></dt><dt><span class="sect1"><a href="#d4e175">3. Changes in Release 6.6.4 - stable (01.11.2008)</a></span></dt><dt><span class="sect1"><a href="#d4e252">4. Changes in Release 6.6.3 - stable (08.08.2008)</a></span></dt><dt><span class="sect1"><a href="#d4e383">5. Changes in Release 6.6.2 - rc (12.12.2007)</a></span></dt><dt><span class="sect1"><a href="#d4e569">6. Changes in Release 6.6.1 - beta (25.02.2007)</a></span></dt><dt><span class="sect1"><a href="#d4e627">7. Changes in Release 6.6.0 - beta (20.10.2006)</a></span></dt><dt><span class="sect1"><a href="#d4e910">8. Changes in Release 6.5</a></span></dt><dt><span class="sect1"><a href="#d4e1185">9. Changes in Release 6.1</a></span></dt><dt><span class="sect1"><a href="#d4e1722">10. Changes in Release 6.0</a></span></dt></dl></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e5"></a>1.&nbsp;Changes in Release 6.6.6 - stable (30.12.2009)</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e7">1.1. Bugs fixed from Mantis Bug Tracker</a></span></dt><dt><span class="sect2"><a href="#d4e36">1.2. Other Bugs fixed</a></span></dt><dt><span class="sect2"><a href="#d4e51">1.3. Features added</a></span></dt><dt><span class="sect2"><a href="#d4e61">1.4. Internal Changes</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e7"></a>1.1.&nbsp;Bugs fixed from Mantis Bug Tracker</h3></div></div></div><p>The bug tracker can be found at: <a href="http://zeosbugs.firmos.at/" target="_top">http://zeosbugs.firmos.at</a></p><div class="itemizedlist"><ul type="disc" compact><li><a href="http://zeosbugs.firmos.at/view.php?id=177" target="_top">#0000177</a> [normal] Type mismatch error on runtime</li><li><a href="http://zeosbugs.firmos.at/view.php?id=210" target="_top">#0000210</a> [Oracle] Bug inserting blob with length = 0</li><li><a href="http://zeosbugs.firmos.at/view.php?id=187" target="_top">#0000187</a> [PostgreSQL] PingServer does (still) not detect lost connections</li><li><a href="http://zeosbugs.firmos.at/view.php?id=207" target="_top">#0000207</a> [PostgreSQL] BlobRead Memory Leak</li><li><a href="http://zeosbugs.firmos.at/view.php?id=194" target="_top">#0000194</a> [IB/FB] ZEOS is replicating NULL values on UPDATE statement </li><li><a href="http://zeosbugs.firmos.at/view.php?id=173" target="_top">#0000173</a> [normal] unable to activate login dialog</li><li><a href="http://zeosbugs.firmos.at/view.php?id=184" target="_top">#0000184</a> [Interbase 5] Can't get fields' list of dataset from Interbase 5.5 server</li><li><a href="http://zeosbugs.firmos.at/view.php?id=183" target="_top">#0000183</a> [Lazarus] Icon for TZIBEventAlerter added</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e36"></a>1.2.&nbsp;Other Bugs fixed</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>[PostgreSQL] Connection string optimization for postgresql (<a href="http://zeos.firmos.at/viewtopic.php?t=2636" target="_top">http://zeos.firmos.at/viewtopic.php?t=2636</a>)</li><li>[Linux] Sqlite3 library name fix for Linux (<a href="http://zeos.firmos.at/viewtopic.php?t=2600" target="_top">http://zeos.firmos.at/viewtopic.php?t=2600</a>)</li><li>[COMMON] Scriptparser error finding a multicharacter delimiter(<a href="http://zeos.firmos.at/viewtopic.php?t=2517" target="_top">http://zeos.firmos.at/viewtopic.php?t=2517</a>)</li><li>[Oracle] Memory leak when reading BLOB values (<a href="http://zeos.firmos.at/viewtopic.php?t=2504" target="_top">http://zeos.firmos.at/viewtopic.php?t=2504</a>)</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e51"></a>1.3.&nbsp;Features added</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>Zeoslib 6.6 is in it's stable phase. No features, except for eventual translations and docs, will (should) be added.</li><li>[COMMON] Added functions TRIM, VAL, CTOD, DTOS, LEFT and RIGHT.</li><li>[COMMON] New property FetchRow in ZDataSet (<a href="http://zeos.firmos.at/viewtopic.php?t=1857" target="_top">http://zeos.firmos.at/viewtopic.php?t=1857</a>)</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e61"></a>1.4.&nbsp;Internal Changes</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>[Lazarus/FPC] Test suite for Lazarus/FPC added.</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e66"></a>2.&nbsp;Changes in Release 6.6.5 - stable (25.05.2009)</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e68">2.1. Bugs fixed from Mantis Bug Tracker</a></span></dt><dt><span class="sect2"><a href="#d4e97">2.2. Other Bugs fixed</a></span></dt><dt><span class="sect2"><a href="#d4e148">2.3. Features added</a></span></dt><dt><span class="sect2"><a href="#d4e170">2.4. Internal Changes</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e68"></a>2.1.&nbsp;Bugs fixed from Mantis Bug Tracker</h3></div></div></div><p>The bug tracker can be found at: <a href="http://zeosbugs.firmos.at/" target="_top">http://zeosbugs.firmos.at</a></p><div class="itemizedlist"><ul type="disc" compact><li><a href="http://zeosbugs.firmos.at/view.php?id=179" target="_top">#0000179</a> [normal] Case problem for unit ZPlainMySqlConstants on linux</li><li><a href="http://zeosbugs.firmos.at/view.php?id=2" target="_top">#0000002</a> [normal] FIREBIRD and NUMERIC/DECIMAL precision problem</li><li><a href="http://zeosbugs.firmos.at/view.php?id=124" target="_top">#0000124</a> [normal] TZSQLMonitor access violation when destroying</li><li><a href="http://zeosbugs.firmos.at/view.php?id=117" target="_top">#0000117</a> [normal] FPC - Float Fields with null values produce many exceptions</li><li><a href="http://zeosbugs.firmos.at/view.php?id=150" target="_top">#0000150</a> [normal] Second JOIN in from clause was stripped by the SQL parser after ON or USING clause</li><li><a href="http://zeosbugs.firmos.at/view.php?id=159" target="_top">#0000159</a> [normal] Fixed case of some *MySql* unit names</li><li><a href="http://zeosbugs.firmos.at/view.php?id=165" target="_top">#0000165</a> [normal] Incorrect autogeneration of INSERT statement</li><li><a href="http://zeosbugs.firmos.at/view.php?id=162" target="_top">#0000162</a> [normal] Precision issue when recording values from TClientDataSet</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e97"></a>2.2.&nbsp;Other Bugs fixed</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>[COMMON] Delphi compiler throws a hint that the assigned return value for ExecuteDirect is never used. (<a href="http://zeos.firmos.at/viewtopic.php?t=2369" target="_top">http://zeos.firmos.at/viewtopic.php?t=2369</a>)</li><li>[IB/FB] Memory leak in TZInterbase6CallableStatement.ExecuteUpdatePrepared (<a href="http://zeos.firmos.at/viewtopic.php?t=2250" target="_top">http://zeos.firmos.at/viewtopic.php?t=2250</a>)</li><li>[IB/FB] Buffer problem with FB2.1 isc_interprete implementation (<a href="http://zeos.firmos.at/viewtopic.php?t=2099" target="_top">http://zeos.firmos.at/viewtopic.php?t=2099</a>)</li><li>[IB/FB] Interbase/Firebid holding connection on shutdown (<a href="http://zeos.firmos.at/viewtopic.php?t=2309" target="_top">http://zeos.firmos.at/viewtopic.php?t=2309</a>)</li><li>[COMMON] Compilation error with SHOW_WARNING directive (<a href="http://zeos.firmos.at/viewtopic.php?t=2312" target="_top">http://zeos.firmos.at/viewtopic.php?t=2312</a>)</li><li>[ADO] SQLServer default GUID fieldlength incorrect (<a href="http://zeos.firmos.at/viewtopic.php?t=2300" target="_top">http://zeos.firmos.at/viewtopic.php?t=2300</a>)</li><li>[PostgreSQL] Bit type fields were not found (<a href="http://zeos.firmos.at/viewtopic.php?t=2260" target="_top">http://zeos.firmos.at/viewtopic.php?t=2260</a>)</li><li>[IB/FB] Subtype is 0 for a computed decimal field and not 1 as in all the other cases (<a href="http://zeos.firmos.at/viewtopic.php?t=2278" target="_top">http://zeos.firmos.at/viewtopic.php?t=2278</a>)</li><li>[COMMON] Make sure dbc connection is nil after ZConnection.Close, even when an exception occurs (<a href="http://zeos.firmos.at/viewtopic.php?t=2275" target="_top">http://zeos.firmos.at/viewtopic.php?t=2275</a>)</li><li>[COMMON] Query property &#8216;ValidateUpdateCount=true/false&#8217; was not added for TZUpdateSQL(<a href="http://zeos.firmos.at/viewtopic.php?t=2249" target="_top">http://zeos.firmos.at/viewtopic.php?t=2249</a>)</li><li>[IB/FB] TZInterbase6DatabaseMetadata.UncachedGetTables: Access Violation and duplicated rows (<a href="http://zeos.firmos.at/viewtopic.php?t=2236" target="_top">http://zeos.firmos.at/viewtopic.php?t=2236</a>)</li><li>[Lazarus] Removed libc from uses clauses when using fpc (<a href="http://zeos.firmos.at/viewtopic.php?t=2196" target="_top">http://zeos.firmos.at/viewtopic.php?t=2196</a>)</li><li>[DELPHI] Removed conditional compilation of database dependent Tokenizers (<a href="http://zeos.firmos.at/viewtopic.php?t=2138" target="_top">http://zeos.firmos.at/viewtopic.php?t=2138</a>)</li><li>[Lazarus] Updated ZUpdateSqlEditor.lrs to be compatible with the newest Lazarus release (<a href="http://zeos.firmos.at/viewtopic.php?t=2095" target="_top">http://zeos.firmos.at/viewtopic.php?t=2095</a>)</li><li>[Oracle] Added TZOracleCachedResolver class because oracle doesn't support queries without FROM clause (<a href="http://zeos.firmos.at/viewtopic.php?t=2080" target="_top">http://zeos.firmos.at/viewtopic.php?t=2080</a>)</li><li>[COMMON] Removed some compiler warnings (<a href="http://zeos.firmos.at/viewtopic.php?t=2081" target="_top">http://zeos.firmos.at/viewtopic.php?t=2081</a>)</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e148"></a>2.3.&nbsp;Features added</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>Zeoslib 6.6 is in it's stable phase. No features, except for eventual translations and docs, will (should) be added.</li><li>[COMMON] TZConnection.Pingserver now resets the ZConnection state when failing (<a href="http://zeos.firmos.at/viewtopic.php?t=2293" target="_top">http://zeos.firmos.at/viewtopic.php?t=2293</a>)</li><li>[GENERAL] Added ZEOS_DISABLE_XXXXX 'Conditional Defines' to Zeos.inc to allow compiling out database support on a per project basis(<a href="http://zeos.firmos.at/viewtopic.php?t=2195" target="_top">http://zeos.firmos.at/viewtopic.php?t=2195</a>)</li><li>[POSTGRES] Implemented ZConnection.ServerVersion for Postgres</li><li>[POSTGRES] Implemented Pingserver for Postgres (<a href="http://zeos.firmos.at/viewtopic.php?t=2156" target="_top">http://zeos.firmos.at/viewtopic.php?t=2156</a>)</li><li>[IB/FB] Implemented Pingserver for IB/FB (<a href="http://zeos.firmos.at/viewtopic.php?t=2274" target="_top">http://zeos.firmos.at/viewtopic.php?t=2274</a>)</li><li>[IB/FB] Added Firebird 2.1 driver (<a href="http://zeos.firmos.at/viewtopic.php?t=2099" target="_top">http://zeos.firmos.at/viewtopic.php?t=2099</a>)</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e170"></a>2.4.&nbsp;Internal Changes</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>NONE</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e175"></a>3.&nbsp;Changes in Release 6.6.4 - stable (01.11.2008)</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e177">3.1. Bugs fixed from Mantis Bug Tracker</a></span></dt><dt><span class="sect2"><a href="#d4e206">3.2. Other Bugs fixed</a></span></dt><dt><span class="sect2"><a href="#d4e242">3.3. Features added</a></span></dt><dt><span class="sect2"><a href="#d4e247">3.4. Internal Changes</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e177"></a>3.1.&nbsp;Bugs fixed from Mantis Bug Tracker</h3></div></div></div><p>The bug tracker can be found at: <a href="http://zeosbugs.firmos.at/" target="_top">http://zeosbugs.firmos.at</a></p><div class="itemizedlist"><ul type="disc" compact><li><a href="http://zeosbugs.firmos.at/view.php?id=147" target="_top">#0000147</a> [normal] Column mapping problem with TZUpdateSql and Refreshing data</li><li><a href="http://zeosbugs.firmos.at/view.php?id=140" target="_top">#0000140</a> [normal] ZUpdateSQL set null as default datetime field value (Firebird)</li><li><a href="http://zeosbugs.firmos.at/view.php?id=136" target="_top">#0000136</a> [normal] Memory leaking on failed Postgres connection</li><li><a href="http://zeosbugs.firmos.at/view.php?id=139" target="_top">#0000139</a> [normal] Some MySQL units are still being compiled when only the SQLite protocol is enabled</li><li><a href="http://zeosbugs.firmos.at/view.php?id=137" target="_top">#0000137</a> [normal] Exception Field '...' cannot be modified (calculated, lookup field) (Adjusted fix for Mantis Bug 99)</li><li><a href="http://zeosbugs.firmos.at/view.php?id=133" target="_top">#0000133</a> [normal] Exception class EZSQLException : attempted update of read-only column (calculated)</li><li><a href="http://zeosbugs.firmos.at/view.php?id=131" target="_top">#0000131</a> [normal] ZIBEventAlerter compile error in Lazarus/Linux</li><li><a href="http://zeosbugs.firmos.at/view.php?id=129" target="_top">#0000129</a> [normal] Access Violation due to forget to assign Connection in TZQuery</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e206"></a>3.2.&nbsp;Other Bugs fixed</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>[COMMON] Bad letter case for unit ZSqlProcessor in ZSqlStrings.pas (<a href="http://zeos.firmos.at/viewtopic.php?t=2067" target="_top">http://zeos.firmos.at/viewtopic.php?t=2067</a>)</li><li>[Postgresql] Replaced the default notice processor which printed to stderr in console applications (and the test suite) (<a href="http://zeos.firmos.at/viewtopic.php?t=2021" target="_top">http://zeos.firmos.at/viewtopic.php?t=2021</a>)</li><li>[COMMON] Escape underscores from the stored procedure name before looking up it's parameters (<a href="http://zeos.firmos.at/viewtopic.php?t=2035" target="_top">http://zeos.firmos.at/viewtopic.php?t=2035</a>)</li><li>[COMMON] Removed table prefixes in generated insert/update statements in property editor for TZSQLUpdate (<a href="http://zeos.firmos.at/viewtopic.php?t=2023" target="_top">http://zeos.firmos.at/viewtopic.php?t=2023</a>)</li><li>[SQLITE] Fixed updates to tables from attached databases (<a href="http://zeos.firmos.at/viewtopic.php?t=2025" target="_top">http://zeos.firmos.at/viewtopic.php?t=2025</a>)</li><li>[ADO] Method calls (GetSchemaNames() and GetCatalogNames()) ran into an exception (<a href="http://zeos.firmos.at/viewtopic.php?t=1774" target="_top">http://zeos.firmos.at/viewtopic.php?t=1774</a>)</li><li>[COMMON] "List out of bounds" in Metadata (<a href="http://zeos.firmos.at/viewtopic.php?t=1995" target="_top">http://zeos.firmos.at/viewtopic.php?t=1995</a>)</li><li>[COMMON] TZSQLProcessor Tokenizer problem (<a href="http://zeos.firmos.at/viewtopic.php?t=1977" target="_top">http://zeos.firmos.at/viewtopic.php?t=1977</a>)</li><li>[MYSQL] Misprint in ZPlainMysqlFunc.inc (<a href="http://zeos.firmos.at/viewtopic.php?t=1979" target="_top">http://zeos.firmos.at/viewtopic.php?t=1979</a>)</li><li>[IB/FB] Memory Leak in TZIBEventAlerter (<a href="http://zeos.firmos.at/viewtopic.php?t=1962" target="_top">http://zeos.firmos.at/viewtopic.php?t=1962</a>)</li><li>[IB/FB] Only link TZIBEventAlerter when ENABLE_INTERBASE is defined (<a href="http://zeos.firmos.at/viewtopic.php?t=1949" target="_top">http://zeos.firmos.at/viewtopic.php?t=1949</a>)</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e242"></a>3.3.&nbsp;Features added</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>NONE. Zeoslib 6.6 is in it's stable phase. No features, except for eventual translations and docs, will be added.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e247"></a>3.4.&nbsp;Internal Changes</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>NONE</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e252"></a>4.&nbsp;Changes in Release 6.6.3 - stable (08.08.2008)</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e254">4.1. Bugs fixed from Mantis Bug Tracker</a></span></dt><dt><span class="sect2"><a href="#d4e319">4.2. Other Bugs fixed</a></span></dt><dt><span class="sect2"><a href="#d4e347">4.3. Features added</a></span></dt><dt><span class="sect2"><a href="#d4e370">4.4. Internal Changes</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e254"></a>4.1.&nbsp;Bugs fixed from Mantis Bug Tracker</h3></div></div></div><p>The bug tracker can be found at: <a href="http://zeosbugs.firmos.at/" target="_top">http://zeosbugs.firmos.at</a></p><div class="itemizedlist"><ul type="disc" compact><li><a href="http://zeosbugs.firmos.at/view.php?id=123" target="_top">#0000123</a> [normal] Can not open TZTable in PostgreSQL (Replaced fix for Mantis Bug 97 (SVN rev. 344) by a more correct one)</li><li><a href="http://zeosbugs.firmos.at/view.php?id=106" target="_top">#0000106</a> [normal] After Post of DataSet with Filtered=True, SortedFields defined, Row position is changed unexpectedly</li><li><a href="http://zeosbugs.firmos.at/view.php?id=122" target="_top">#0000122</a> [normal] Problem with quoted fields (PostgreSQL keywords)</li><li><a href="http://zeosbugs.firmos.at/view.php?id=121" target="_top">#0000121</a> [normal] ZQuery Insert/Update problem with MSSQL/ADO</li><li><a href="http://zeosbugs.firmos.at/view.php?id=119" target="_top">#0000119</a> [normal] Memory leak in ZDbcSqLiteResultSet.pas</li><li><a href="http://zeosbugs.firmos.at/view.php?id=113" target="_top">#0000113</a> [high] MYSQL - EZSQLException with message 'Column with name "Extra" was not found'. using latest MySQL 5.1.x</li><li><a href="http://zeosbugs.firmos.at/view.php?id=108" target="_top">#0000108</a> [normal] Duplicated result when using locate, loPartialKey and Filter</li><li><a href="http://zeosbugs.firmos.at/view.php?id=111" target="_top">#0000111</a> [normal] Lookup field value disappers on insert and edit and reappears after post or cancel</li><li><a href="http://zeosbugs.firmos.at/view.php?id=105" target="_top">#0000105</a> [normal] Fields default expresion is determined from the wrong source</li><li><a href="http://zeosbugs.firmos.at/view.php?id=95" target="_top">#0000095</a> [normal] It is impossible to be connected to base on tcpip</li><li><a href="http://zeosbugs.firmos.at/view.php?id=99" target="_top">#0000099</a> [normal] Read only fields not really read only</li><li><a href="http://zeosbugs.firmos.at/view.php?id=94" target="_top">#0000094</a> [normal] Invalid argument to time encode</li><li><a href="http://zeosbugs.firmos.at/view.php?id=97" target="_top">#0000097</a> [normal] Cannot open table where tablename is similar to database name (Quoting TZTable.tablename)</li><li><a href="http://zeosbugs.firmos.at/view.php?id=93" target="_top">#0000093</a> [normal] Wrong clearing of allocated data for SQLDA</li><li><a href="http://zeosbugs.firmos.at/view.php?id=90" target="_top">#0000090</a> [normal] Default values from table are not used / Corrected Null fields handling in combination with autoinc and default values</li><li><a href="http://zeosbugs.firmos.at/view.php?id=88" target="_top">#0000088</a> [normal] Delphi11 test packages missing in ZEOSLIB_TESTING_REV329</li><li><a href="http://zeosbugs.firmos.at/view.php?id=86" target="_top">#0000086</a> [normal] Field values truncated</li><li><a href="http://zeosbugs.firmos.at/view.php?id=87" target="_top">#0000087</a> [normal] Backslash gone in resultset</li><li><a href="http://zeosbugs.firmos.at/view.php?id=82" target="_top">#0000082</a> [normal] Incorrect catalog name when no schema present and incorrect order</li><li><a href="http://zeosbugs.firmos.at/view.php?id=80" target="_top">#0000080</a> [high] Naming convention in release build...</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e319"></a>4.2.&nbsp;Other Bugs fixed</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>[COMMON] Enabled BeforeRefresh and AfterRefresh Dataset properties for FPC2 (<a href="http://zeos.firmos.at/viewtopic.php?t=1749" target="_top">http://zeos.firmos.at/viewtopic.php?t=1749</a>)</li><li>[COMMON] Quoted Aliases in queries were not recognised (<a href="http://zeos.firmos.at/viewtopic.php?t=1797" target="_top">http://zeos.firmos.at/viewtopic.php?t=1797</a>)</li><li>[COMMON] In Delphi 2006 and FPC 2.1 TWideStringField.SetAsWideString() puts a PWideChar into the buffer, so deserializing it as a PWideString is probably wrong. (<a href="http://fisheye3.cenqua.com/changelog/heidisql?cs=1383" target="_top">http://fisheye3.cenqua.com/changelog/heidisql?cs=1383</a>)</li><li>[COMMON] Remove "TextHeight = 13" from UpdateSql Editor in Lazarus (<a href="http://zeos.firmos.at/viewtopic.php?t=1872" target="_top">http://zeos.firmos.at/viewtopic.php?t=1872</a>)</li><li>[COMMON] Don't use ASM call in TZCollection.Error when using FPC. FPC should be able to do this platform independent (<a href="http://zeos.firmos.at/viewtopic.php?t=1882" target="_top">http://zeos.firmos.at/viewtopic.php?t=1882</a>)</li><li>[COMMON] Fixed Delphi5 compilation</li><li>[COMMON] Join two tokens if the first is a ttInteger and the next a ttWord (<a href="http://zeos.firmos.at/viewtopic.php?t=1897" target="_top">http://zeos.firmos.at/viewtopic.php?t=1897</a>)</li><li>[IB/FB] Metadata.GetColumns corrected (<a href="http://zeos.firmos.at/viewtopic.php?t=1682" target="_top">http://zeos.firmos.at/viewtopic.php?t=1682</a>)</li><li>[IB/FB] Autocommit didn't work for TZStoredProcedure when using Firebird</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e347"></a>4.3.&nbsp;Features added</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>[COMMON] Added polish translation</li><li>[SQLite3] Improve Column Affinity (<a href="http://zeos.firmos.at/viewtopic.php?t=1605" target="_top">http://zeos.firmos.at/viewtopic.php?t=1605</a>)</li><li>[COMMON] Added ZConnection.ExecuteDirect and ZConnection.ExecuteUpdateDirect functions (<a href="http://zeos.firmos.at/viewtopic.php?t=1656" target="_top">http://zeos.firmos.at/viewtopic.php?t=1656</a>)</li><li>[COMMON] Automatically generated updates could update more than 1 row at once or no row at all. Query property &#8216;ValidateUpdateCount=true/false&#8217; added (<a href="http://zeos.firmos.at/viewtopic.php?t=1757" target="_top">http://zeos.firmos.at/viewtopic.php?t=1757</a>)</li><li>[COMMON] Added ZIBEventAlerter to the components package</li><li>[COMMON] Added TZTable.exists (<a href="http://zeos.firmos.at/viewtopic.php?t=1879)" target="_top">http://zeos.firmos.at/viewtopic.php?t=1879)</a>)</li><li>[IB/FB] Added support for Firebird hard commits. (Very experimental!!!)</li><li>[MYSQL] Added libmysql51.dll to list of possible dll's for protocol Mysql-5</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e370"></a>4.4.&nbsp;Internal Changes</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>[COMMON] ant build support for Linux added</li><li>[COMMON] Added GetXxxCacheKey functions (<a href="http://zeos.firmos.at/viewtopic.php?t=1881" target="_top">http://zeos.firmos.at/viewtopic.php?t=1881</a>)</li><li>[COMMON] Removed caching code that was identical between all descendent classes of TZAbstractDatabaseMetadata (<a href="http://zeos.firmos.at/viewtopic.php?t=1881" target="_top">http://zeos.firmos.at/viewtopic.php?t=1881</a>)</li><li>[MYSQL] Added new constants for mysql 5.1 library</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e383"></a>5.&nbsp;Changes in Release 6.6.2 - rc (12.12.2007)</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e385">5.1. Bugs fixed from Mantis Bug Tracker</a></span></dt><dt><span class="sect2"><a href="#d4e466">5.2. Other Bugs fixed</a></span></dt><dt><span class="sect2"><a href="#d4e508">5.3. Features added</a></span></dt><dt><span class="sect2"><a href="#d4e554">5.4. Internal changes</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e385"></a>5.1.&nbsp;Bugs fixed from Mantis Bug Tracker</h3></div></div></div><p>The bug tracker can be found at: <a href="http://zeosbugs.firmos.at/" target="_top">http://zeosbugs.firmos.at</a></p><div class="itemizedlist"><ul type="disc" compact><li>#0000022: [general] Split ZPlainMysql.inc</li><li>#0000023: [component] Problem using WideStrings and ADO protocol when chaging any WideString Field Data, same nature as Issue 0010 (fduenas)</li><li>#0000016: [core] Integer field treated as Largeint </li><li>#0000005: [postgresql] Memory grow when connection failed</li><li>#0000013: [interbase/firebird] can not use a string as parameter value for integer/long parameters</li><li>#0000019: [interbase/firebird] string parameters don't work for blob fields</li><li>#0000033: [interbase/firebird] Fixes a bug in UpdateString procedure for ZDbcInterbase6Utils </li><li>#0000034: [interbase/firebird] Lookup field make other field in TZQuery lost the value (disappear from display but still exists in database)</li><li>#0000020: [interbase/firebird] second call to stored proc fail with a parameter mismatch error (cipto_kh)</li><li>#0000040: [component] Error in conversion int64 to variant in InternalPost on Delphi/C++Builder 5 (ZAbstractDataset.pas)</li><li>#0000042: [general] Using the same component (TZStoredProcedure) after ExecProc then using Open it will crash (cipto_kh)</li><li>#0000037: [component] ZEOS AND LAZARUS 0.9.23 and FPC 2.1.3 WIN32 ERROR</li><li>#0000038: [component] Can't open sqlite databases with Umlauts like &auml;&ouml;&uuml; in path (fixed)</li><li>#0000046: [component] fpc 2.1.4 cannot compile ZAbstractRODataset.pas</li><li>#0000028: [interbase/firebird] TZInterbase6DatabaseMetadata.HasNoWildcards - wrong result (cipto_kh)</li><li>#0000055: [component] Wrong index variable used when doing "refresh" in ZUpdateSQL component</li><li>#0000050: [postgresql] 'Access Violation' error on ZQuery.Open on table that has columns with non-standard type</li><li>#0000041: [postgresql] TZPostgreSQLDatabaseMetadata.GetSequences return not schema-qualified sequence list (ZDbcPostgreSqlMetadata.pas)</li><li>#0000049: [core] Lookup fields with int64 data type not work in Delphi/C++Builder 5</li><li>#0000007: [interbase/firebird] TZSequence error, value from prior database (cipto_kh)</li><li>#0000048: [general] TZSQLProcessor does not react when Script text is not properly delimited</li><li>#0000056: [component] Protection fault when doing an EAbort exception in BeforeConnect of TZConnection (patch incl.)</li><li>#0000064: [parsesql] Mysql /*! ...*/ special comments shouldn't be considered as real comments</li><li>#0000063: [component] TZSQLProcessor and comments handling</li><li>#0000061: [component] Wrong data returning in select</li><li>#0000065: [general] FPC 2.2 doesn't compile</li><li>#0000068: [postgresql] Wrong datatype declared</li><li>#0000043: [component] ReadOnlyQuery + TDataSetProvider = Blank fields on details</li><li>#0000059: [component] ZQuery-DSP-CDS empty field data fetched while using incremental fetching (PacketRecords&gt;0</li><li>#0000027: [interbase/firebird] problem handling DEFAULT NULL in domain *AND* in table</li><li>#0000069: [general] Compiler Warnings in Delphi 2006</li><li>#0000071: [interbase/firebird] Floating point not display correctly (cipto_kh)</li><li>#0000076: [mysql] SSL Connection Error</li><li>#0000075: [sqlite] Memory Error Detected</li><li>#0000070: [general] Missing license files</li><li>#0000079: [dbc] Typo in SQl statement in TZInterbase6Connection.Open;</li><li>#0000017: [mysql] LargeInt fields treated as Variant</li><li>#0000060: [sqlite] Memory leaks in sqlite-3 driver</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e466"></a>5.2.&nbsp;Other Bugs fixed</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>Metadata (mdTables) was missing remarks data (http://zeos.firmos.at/viewtopic.php?t=1567)</li><li>Memory leaks (http://zeos.firmos.at/viewtopic.php?t=1408)</li><li>Correction of child dataset refresh (http://zeos.firmos.at/viewtopic.php?t=1381)</li><li>Set autocommit issue when transaction isolation=tiNone (http://zeos.firmos.at/viewtopic.php?t=1251)</li><li>TZAdoDatabaseMetadata.GetColumns doesn't fetch database and schema names. (http://zeos.firmos.at/viewtopic.php?t=1252)</li><li>TZRowAccessor.CompareBuffers didn't work for stUnicodeStreams (http://zeos.firmos.at/viewtopic.php?t=1254)</li><li>TZSQLStrings.StatementCount = 1 when the statement is empty (http://zeos.firmos.at/viewtopic.php?t=1228)</li><li>Error handling empty string values (makes them NULLS) (http://zeos.firmos.at/viewtopic.php?t=1255)</li><li>Read blob truncates last byte for ADO (http://zeos.firmos.at/viewtopic.php?t=1250)</li><li>Close/Open sequence replaced by refresh in TZAbstractRODataset.RefreshParams (http://zeos.firmos.at/viewtopic.php?t=1093)</li><li>Wrong mysql version reference in GetMoreResults function</li><li>Required should be false if a field is not writable (http://zeos.firmos.at/viewtopic.php?t=767)</li><li>Avoid open/close of detail dataset on edit of master dataset (http://zeos.firmos.at/viewtopic.php?t=1093)</li><li>FreeAndNil fix in ZSequence - (http://zeos.firmos.at/viewtopic.php?t=1108)</li><li><p>Mysql fixes by HeidiSQL Team (Repository viewer at http://fisheye3.cenqua.com/changelog/heidisql)</p><div class="itemizedlist"><ul type="circle" compact><li>Avoid an access violation within a for loop which got run once even when there were 0 columns in a result. (HeidiSql rev. 993)</li><li>Fix bug "SHOW FULL PROCESSLIST on mysql v4 server messes Zeos up". (HeidiSql rev. 775 and 900)</li><li>Fix handling default values. (HeidiSql rev. 505)</li><li>Zeos did not recognize UNSIGNED ZEROFILL columns as being UNSIGNED. (HeidiSql rev. 521)</li></ul></div></li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e508"></a>5.3.&nbsp;Features added</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>All mysql_options() and connection clientflag settings can now be set using TZConnection.Properties (http://zeos.firmos.at/viewtopic.php?t=1528)</li><li>Updated indonesian translations (by tohenk)</li><li>Added Russian translation (by ormada)</li><li>Use Mysql_real_escape_string instead of mysql_escape_string when executing mysql emulated prepared statements</li><li>Added IZConnection.EscapeString function. This funtion returns a string that can be used in SQL statements. Uses Mysql_real_escape_string or Mysql_escape_string functions for mysql databases and EncodeCString function for other databases</li><li>FPC changes -&gt; now zeoslib also works with MSEIDE - By MSEIDE team (http://www.homepage.bluewin.ch/msegui)</li><li>Added all reserved words, functions from mysql 5.1 documentation to metadata GetXXX functions (http://zeos.firmos.at/viewtopic.php?t=1213)</li><li>Replaced 'Select' in Getversion to Native library call</li><li>Added support for Mysql SSL connections</li><li>Added TZConnection.GetColumnNames function (http://zeos.firmos.at/viewtopic.php?t=1127)</li><li>Added Delphi2007 package files (http://zeos.firmos.at/viewtopic.php?t=1173)</li><li>Changed PingServer behaviour : Only return false when ping fails. No exception. This function is a check, so it should be allowed to return false. On demand of HeidiSql team. </li><li>Modified Readme text for mysql embedded server example</li><li>Added Multiple resultset support on Dbc level (http://zeos.firmos.at/viewtopic.php?t=459 and http://zeos.firmos.at/viewtopic.php?t=912)</li><li>ZDataset Events in Lazarus (http://zeos.firmos.at/viewtopic.php?t=1130)</li><li><p>New Features by HeidiSQL Team (Repository viewer at http://fisheye3.cenqua.com/changelog/heidisql)</p><div class="itemizedlist"><ul type="circle" compact><li>Added unknown data types from mysql_com.h. (HeidiSQL rev. 835)</li><li>Make ConvertMySQLHandleToSQLType() more readable (HeidiSql rev. 676)</li><li>Ignore columns that do not originate from the table when resolving updates (HeidiSql rev. 555)</li><li>Added function TZAbstractResultSetMetadata.HasDefaultValue (HeidiSql rev. 504)</li><li>TZConnection.Reconnect added (HeidiSql rev. 53)</li></ul></div></li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e554"></a>5.4.&nbsp;Internal changes</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>Release build script has been rewritten</li><li>Fixed the automatic build system and test suite. Works now certainly for D5, D7, D2006, D2007</li><li>Added SVN ant utilities to repository so build scripts should run on a standard Ant installation</li><li>Added Lazarus/Fpc to the automatic build system. Test suite is not available, however. Package *.pas files are necessary for automated build system.</li><li>Removed some compiler warnings and unused units.</li><li>Start of the zeoslib documentation project using doxygen</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e569"></a>6.&nbsp;Changes in Release 6.6.1 - beta (25.02.2007)</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e571">6.1. Bugs fixed</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e571"></a>6.1.&nbsp;Bugs fixed</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>#0000003: Field confusion in GetColumnInfo</li><li><p>#0000010: Widestring field's contents Using ado protocol and access database is unreadable</p><p>When using a TzQuery or TZTable using ado protocol and an access database with OLEDB Jet engine, the contents of any TWideString field is unreadable (it returns symbols) and sometimes throws Out of Memory error.</p></li><li>#0000016: Integer field treated as Largeint</li><li>#0000003: Field confusion in GetColumnInfo</li><li><p>#0000021: ClientVersion and ServerVersion properties fail on closed connection</p><p>When calling ClientVersion and ServerVersion on a closed mysql connection they refer to an unassigned object.</p></li><li><p>#0000023: Problem using WideStrings and ADO protocol when chaging any WideString Field Data, same nature as Issue #0000010</p><p>When using a TzQuery or TZTable using ado protocol and an access database with OLEDB Jet engine, when changing the the contents of any TWideString field, the values is unreadable (it returns symbols) and sometimes throws Out of Memory error.</p></li><li>EOutofMemory with Delphi 2006 + Firebird (http://zeos.firmos.at/viewtopic.php?t=972)</li><li>Zeos 6.6-Beta: func GetTableNames() / PingServer (http://zeos.firmos.at/viewtopic.php?t=992)</li><li>Race happens? (http://zeos.firmos.at/viewtopic.php?t=974)</li><li>MySQL and FLOAT fields (precision) (http://zeos.firmos.at/viewtopic.php?t=930)</li><li>Memory Leak - ZeosLib 6.5.1, MySQL 4.1, Lazarus (http://zeos.firmos.at/viewtopic.php?t=812)</li><li>Bug in ZAbstractRODataset (6.6.0 beta version) (http://zeos.firmos.at/viewtopic.php?t=898)</li><li>Bug in ZDbcPostgreSqlMetadata.pas(6.6 beta) (http://zeos.firmos.at/viewtopic.php?t=839)</li><li>Postgres Blob field bug (http://zeos.firmos.at/viewtopic.php?t=931)</li><li>Do not work sorterfields (http://zeos.firmos.at/viewtopic.php?t=920)</li><li>Fix for TZInterbase6DatabaseMetadata.GetSequence (http://zeos.firmos.at/viewtopic.php?t=864)</li><li>ERangeError after FormCreate (http://zeos.firmos.at/viewtopic.php?t=902)</li><li>Delphi5 and MySql5 (http://zeos.firmos.at/viewtopic.php?t=886)</li><li>Zquery and Ztable not accept numeric database (http://zeos.firmos.at/viewtopic.php?t=882)</li><li>BCB6 ZDbc.bpk (http://zeos.firmos.at/viewtopic.php?t=854)</li><li>Fix for Bug in ZInterbase6Sequence.GetNextValue (http://zeos.firmos.at/viewtopic.php?t=856)</li><li>ztable problem : editing and TableName (http://zeos.firmos.at/viewtopic.php?t=748)</li><li>MySQL: Cannot update this query type(backticks) (http://zeos.firmos.at/viewtopic.php?t=552)</li><li>InterBase/FireBird BLOB handling error (http://zeos.firmos.at/viewtopic.php?t=855)</li><li>Duplicate messages in portuguese language (ttp://zeos.firmos.at/viewtopic.php?t=848)</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e627"></a>7.&nbsp;Changes in Release 6.6.0 - beta (20.10.2006)</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e629">7.1. Features added</a></span></dt><dt><span class="sect2"><a href="#d4e744">7.2. Patches applied</a></span></dt><dt><span class="sect2"><a href="#d4e761">7.3. Bugs fixed</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e629"></a>7.1.&nbsp;Features added</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>LinkedFieldNames vs. IndexFieldnames (See http://zeos.firmos.at/viewtopic.php?t=796) </li><li>New Dataset features : BeforeApplyUpdates (event), AfterApplyUpdates (event), SortType (property), EmptyDataSet (procedure) </li><li>Added separate drivers for embedded Firebird server (http://zeos.firmos.at/viewtopic.php?t=630) </li><li>Delphi 2006 packages </li><li>Mysql5 Support integrated </li><li>PostgreSQL 8.x Support integrated </li><li>Added Sybase Adapitive Serve Anywhere (ASA) Support for Versions 7, 8 and 9.</li><li>MySQL Ping Commando added </li><li>Insert "const" for ref-counted parameter (http://zeos.firmos.at/viewtopic.php?t=519) </li><li>MySQL Embedded Server Arguments (http://zeos.firmos.at/viewtopic.php?t=777) </li><li>separated Firebird from interbase/strict dll loading for Firebird </li><li>TZConnection: property 'Version', showing the current version </li><li>Support for fkInternalCalcFields in datasets </li><li>Added property DesignConnection: If DesignConnection is true connected is not set to true during runtime and must be set explicitly </li><li>Enabled all connection options for mysql. Now one can add the desired options by adding them to the connections property strings. </li><li>Rewrite of ZPlainMysqlXX files to add embedded server support for versions 4.0,4.1,5 of  mysql </li><li>Added new library functions to plain mysql drivers (4.1) </li><li>Added new library functions to plain mysql drivers (3.23 and 3.20) </li><li>Error handling for Postgres now returns result codes from server </li><li>Two Phase Commit for PostgreSQL </li><li>Added parameter capability to TZSQLProcessor so you now can use parameters inside your SQL scripts like you do in "normal" queries.</li><li>Added const "ZEOS_VERSION" to ZClasses and added property "Version" to TZConnection.</li><li>Added support of fkInternalCalcFields for ZEOS datasets.</li><li>Added property "DesignConnection" to turn off active design time connections during runtime, automatically.</li><li>Added PropertyEditor for TField-properties in several components.</li><li><p>Added default values to the following properties:</p><div class="itemizedlist"><ul type="circle" compact><li>TZAbstractRODataset.RequestLive: False</li><li>TZAbstractRODataset.ParamCheck: True</li><li>TZAbstractRODataset.ShowRecordTypes: [usUnmodified, usModified, usInserted]</li><li>TZAbstractRODataset.IsUniDirectional: False</li><li>TZAbstractRODataset.Options: [doCalcDefaults]</li><li>TZAbstractRODataset.ReadOnly: True</li><li>TZAbstractDataset.UpdateMode: umUpdateChanged</li><li>TZAbstractDataset.WhereMode: wmWhereKeyOnly</li><li>TZAbstractDataset.CachedUpdates: False</li><li>TZConnection.SQLHourGlass: False</li><li>TZQuery.ReadOnly: False</li><li>TZTable.ReadOnly: False</li><li>TZSqlMetadata.Scope: 0</li><li>TZSqlMetadata.Nullable: False</li><li>TZSqlMetadata.Unique: False</li><li>TZSqlMetadata.Approximate: False</li></ul></div></li><li><p>/<span class="othername">SG</span>/ Changed default values for following properties:</p><div class="itemizedlist"><ul type="circle" compact><li>TZConnection.ReadOnly: False</li></ul></div></li><li><p>/<span class="othername">SG</span>/ Changed following default initializations:</p><div class="itemizedlist"><ul type="circle" compact><li>- TZAbstractDataset.RequestLive := True;</li><li>TZConnection.ReadOnly := False;</li></ul></div></li><li><p>/<span class="othername">SG</span>/ Changed following property names:</p><div class="itemizedlist"><ul type="circle" compact><li>TZQuery.RequestLive --&gt; TZQuery.ReadOnly</li></ul></div></li><li>/<span class="othername">SG</span>/ Added parameter capability to TZSQLProcessor like in TZQuery.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e744"></a>7.2.&nbsp;Patches applied</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>Const and optimization (http://zeos.firmos.at/viewtopic.php?t=551)</li><li>MissingConsts, Inlining, SilentException (http://zeos.firmos.at/viewtopic.php?t=566)</li><li>Packages for delphi 6 (http://zeos.firmos.at/viewtopic.php?t=577)</li><li>PostgreSQL EncodeString() (http://zeos.firmos.at/viewtopic.php?t=589)</li><li>Date, Time and Float on Lazarus (http://zeos.firmos.at/viewtopic.php?t=598)</li><li>Updates for ZMessages (translations)</li><li>Const modifier added to function definitions where possible to improve speed (http://zeos.firmos.atviewtopic.php?t=519)</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e761"></a>7.3.&nbsp;Bugs fixed</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>ZDbcConnection.pas contains wrong line breaks (http://zeos.firmos.at/viewtopic.php?t=553)</li><li>Other files with LF instead of CRLF (http://zeos.firmos.at/viewtopic.php?t=554)</li><li>svn rev. 59 (Linux filenames problem) (http://zeos.firmos.at/viewtopic.php?t=593)</li><li>error type date in lazarus (http://zeos.firmos.at/viewtopic.php?t=574)</li><li>MySQL v.5.0 .3+ and Decimals (http://zeos.firmos.at/viewtopic.php?t=605)</li><li>ZSqlUpdate append error (http://zeos.firmos.at/viewtopic.php?t=677)</li><li>Error opening Query (http://zeos.firmos.at/viewtopic.php?t=628)</li><li>Compiling in Borland C++ Builder 6 (http://zeos.firmos.at/viewtopic.php?t=694)</li><li>compiling for delphi5/6 (http://zeos.firmos.at/viewtopic.php?t=802)</li><li>Memory leak MSSQL2000 TZQuery.ExecSQL (http://zeos.firmos.at/viewtopic.php?t=788)</li><li>ZEOS_TESTING_REV_113 Sybase-Bug (http://zeos.firmos.at/viewtopic.php?t=822)</li><li>Removed Rangecheck Directive (all files) (FPC 2.0.2 is buggy)</li><li>Updated lazarus package for correct compilation. (Missing packages, corrupt package file,...)</li><li>Some more Lazarus package modifications</li><li>Memory leak bug fixed (http://zeos.firmos.at/viewtopic.php?t=461)</li><li>Delimiter problem in ZSQLProcessor fixed (http://zeos.firmos.at/viewtopic.php?t=527)</li><li>Fixed Delphi 5 install problems (http://zeos.firmos.at/viewtopic.php?t=335)</li><li>Added {$LIBSUFFIX 'X0'} to projectfiles of D7 and D2006 (http://zeos.firmos.at/viewtopic.php?t=561)</li><li>Removed ASA driver from Lazarus packages because not compilable in Lazarus.</li><li>Bug in GetIndexInfo (http://zeos.firmos.at/viewtopic.php?t=196)</li><li>Added GetClientVersion and GetServerVersion to Connection/Driver interfaces</li><li>Integrated contribution from Terence : Added more specific metadata clearcache possibilities.</li><li>Delphi 7 : Split up Component Package into Component and ComponentDesign (http://zeos.firmos.at/viewtopic.php?t=726)</li><li>Delphi 7 : Added compiler directives to avoid inclusion of not wanted database drivers. (http://zeos.firmos.at/viewtopic.php?t=746)</li><li>InternalPost (Procedure) (http://zeos.firmos.at/viewtopic.php?t=781)</li><li>Updatesql component (OnUpdate event)</li><li>Mssql Select * error (http://zeos.firmos.at/viewtopic.php?t=788)</li><li>Added Lazarus fixes : ASA support did not compile well.</li><li>Firebird: Memory leak bug fixed (http://zeos.firmos.at/viewtopic.php?t=461)</li><li>Corrections for non-strict dllloading</li><li>Bytea/blob - PostgreSQL - UNICODE/UTF8 (http://zeos.firmos.at/viewtopic.php?t=683)</li><li>Integrated patch from Fduenas concerning http://zeos.firmos.at/viewtopic.php?t=677</li><li>Mysql MetaData Patch to support temporary tables</li><li>Corrected the temporary tables patch. Now it tries to get information on a 'non-existing' table, just in case it is a temporarary one. If it is temporary the table is added to the cache If it's not, the resulting error is suppressed but the table will stay unknown.</li><li>Various modifications/extentions to Mysql DBC and Plain driver units - Written by fduenas and mdaems</li><li>Removed calls to Mysql datastructure where possible (Only necessary for mysql3.20) - written by mdaems</li><li>Bad tiReadCommited corrected (http://zeos.firmos.at/viewtopic.php?t=570)</li><li>Widestring Fields are always returning Null if one tries to access property Value.</li><li>Firebird 1.5: field named "STATUS_REG" that doesn't show in TZDataSet.</li><li>FPC/Lazarus: Connecting to a Firebird Database will cause a Range Check Error.</li><li>Zeos appears to be bringing back Postgresql money type as ftfloat instead of ftcurrency.</li><li>Row inserting is impossible with simple queries when TZQuery.ReadOnly property set to false and no TZQuery.UpdateObject defined.</li><li>In the metadata, all user tables were being reported as type VIEW.</li><li>Problem in ZSysUtils.BytesToVar().</li><li>Problem with TZAbstractDataset.InternalPost.</li><li>When using GetPChar()  Result of GetPChar() points to unallocated memory.</li><li>ZeosDBO (Ado) update problem with TZUpdateSQL</li><li>Username property not refreshed if changed in login box</li><li>Problem with TZTable refresh method</li><li>IProviderSupport - PSUpdateRecord</li><li>Firebird 1.5 Read Only Database on CD</li><li>ZQuery's FieldsEditor brings diff. types for the same field</li><li>Login Dialog unstable appearance</li><li>Wrong results for lookup fields</li><li>open cursors in Oracle</li><li>Change data when Dataset.State = dsBrowse</li><li>Exception when deleting record with ClientDataSet</li><li>Strange behaviour Zeos - DBLookUpComboBox</li><li>CreateStatement and Properties</li><li>WideString Updates</li><li>MySQL:zeos doesnt assign default '0000-00-00' to Date Fields</li><li>TZAbstractRODataset.RereadRows;</li><li>CaseSensitive locate on WideString fields</li><li>Filter issues</li><li>AV error when opening a DML with a TZQuery using doSmartOpen</li><li>Incorrect TZPostgreSQLNotify definition</li><li>Access violation on large string fields.</li><li>MySQL Date/Time bug + Fix</li><li>Firebird 1.5: unsupported datatype</li><li>Startup failing if compiled with "Full Boolean Evaluation"</li><li>SetFieldData for ftString don't refresh</li><li>ADO TDateTime parameter wrong type</li><li>TZTable's TabeleName Property - not list with ADO protocol</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e910"></a>8.&nbsp;Changes in Release 6.5</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e912">8.1. Release 6.5.1 - 23 Nov 2004</a></span></dt><dt><span class="sect2"><a href="#d4e923">8.2. Release 6.5.1 - 17 July 2004</a></span></dt><dt><span class="sect2"><a href="#d4e986">8.3. Release 6.5.0 - 10 March 2004</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e912"></a>8.1.&nbsp;Release 6.5.1 - 23 Nov 2004</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">CNL</span>/ Fixed Bug#912639 Result sets were not decoded</li><li>/<span class="othername">CNL</span>/ Another version of PostgreSQLToSQLType() is added to boost execution speed</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e923"></a>8.2.&nbsp;Release 6.5.1 - 17 July 2004</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SM</span>/ Fixed Bug#1021705 Numeric values overflow</li><li>/<span class="othername">SM</span>/ Fixed Bug#1034795 Metadata don't filter the table type</li><li>/<span class="othername">SM</span>/ Fixed Bug#993352 problem with TZInterbase6DatabaseMetadata.GetTables table type SYSTEM TABLE</li><li>/<span class="othername">SM</span>/ Fixed Bug#991069 Creation of a DB and FKs in Firebird</li><li>/<span class="othername">SS</span>/ Fixed Bug#985629 Locate and Lookup don't find float fields.</li><li>/<span class="othername">SS</span>/ Added database error codes to rethrown exceptions in dataset.</li><li>/<span class="othername">SS</span>/ Fixed Bug#993981 MySQL and PostgreSQL drivers do not process float values if decimal separator other then &#8220;<span class="quote">.</span>&#8221;.</li><li>/<span class="othername">SS</span>/ Fixed Bug#995080 &#8220;<span class="quote">List Index Out of Bounds</span>&#8221; exception in <tt class="classname">Dataset</tt>.<tt class="methodname">UpdateStatus</tt> on empty resultset.</li><li>/<span class="othername">SS</span>/ Fixed Bug#999658 Truncation of BigDecimal fields. Thanks to Kestutis Laurinavicius.</li><li>/<span class="othername">SS</span>/ Fixed Bug#1000534. SQL Parser error when &#8220;<span class="quote">join ... on</span>&#8221; clause contains functions with parameters.</li><li>/<span class="othername">SS</span>/ Fixed Bug#1004534 Access Violation when <tt class="methodname">RecNo</tt> is called on closed Dataset.</li><li>/<span class="othername">SS</span>/ Fixed Bug#1045286 Method <tt class="methodname">IsNull</tt> returns incorrect result for fields containing &#8220;<span class="quote"></span>&#8221; characters.</li><li>/<span class="othername">SS</span>/ Added support for cidr, inet and macaddr column types into PostgreSQL driver.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e986"></a>8.3.&nbsp;Release 6.5.0 - 10 March 2004</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Added IProviderSupport interface implementation to datasets.</li><li>/<span class="othername">SS</span>/ Added support for MySQL 4.1 database.</li><li>/<span class="othername">SS</span>/ Added support for PostgreSQL 7.4 database.</li><li>/<span class="othername">SS</span>/ Added support for Oracle 9i database.</li><li>/<span class="othername">SS</span>/ Fixed Bug#981208 SELECT * FROM mydb.mytable is not updateable.</li><li>/<span class="othername">SS</span>/ Replaced thrown exception type from Datasets to <tt class="classname">EZDatabaseError</tt> custom class.</li><li>/<span class="othername">SS</span>/ Fixed Bug#966267 Fixed processing OnEditError, OnPostError, OnDeleteError events.</li><li>/<span class="othername">SS</span>/ Fixed memory leak in <tt class="classname">Statement</tt>.<tt class="methodname">Execute</tt>. Now all <tt class="classname">Connections</tt>, <tt class="classname">Statements</tt> and <tt class="classname">ResultSets</tt> must be explicitely closed before desposing.</li><li>/<span class="othername">SS</span>/ Added doSmartOpen option to <tt class="classname">Dataset</tt> to allow executing DML statements by <tt class="methodname">Open</tt> without throwing exception. </li><li>/<span class="othername">SM</span>/ Fixed Bug#959307 <tt class="classname">TZDBLibCallableStatement</tt>.<tt class="methodname">Execute</tt> Empty parameter string sever translate as null value</li><li>/<span class="othername">SM</span>/ Fixed Bug#907497 <tt class="classname">TZDBLibCallableStatement</tt>.<tt class="methodname">ExecutePrepared</tt> Return incorrect string values of stored procedure</li><li>/<span class="othername">SM</span>/ Fixed Bug#951881 <tt class="classname">TZFirebirdNativeLibraryLoader</tt> Interbase do not work with INTERBASE_CRYPT enabled</li><li>/<span class="othername">SM</span>/ Fixed #956613 <tt class="classname">TZInterbase6DatabaseMetadata</tt>.<tt class="methodname">GetTables</tt> Error in metadata reading</li><li>/<span class="othername">SM</span>/ Fixed #947915 <tt class="classname">TZInterbase6CallableStatement</tt>.<tt class="methodname">ExecuteUpdatePrepared</tt> do noit raised exception in Stored Procedure</li><li>/<span class="othername">SM</span>/ Fixed #945251 <tt class="classname">TZAbstractDatabaseMetadata</tt>.<tt class="methodname">GetTableTypes</tt> always returns &#8220;<span class="quote">TABLE</span>&#8221; as result, never&#8220;<span class="quote">VIEW</span>&#8221; and never &#8220;<span class="quote">SYSTEM TABLE</span>&#8221;.</li><li>/<span class="othername">SS</span>/ Fixed Bug#914057 <tt class="classname">ZSQLMonitor</tt>.<tt class="methodname">SaveToFile</tt> don't use <span class="property">FileName</span>.</li><li>/<span class="othername">SM</span>/ Fixed Bug #914436 Text fields with specified character set are not recognized in MySQL driver.</li><li>/<span class="othername">SM</span>/ Fixed Bug #914369 Fixed memory leaks in Interbase driver</li><li>/<span class="othername">SS</span>/ Fixed Bug#912220 PostgreSQL driver doesn't read oid blobs.</li><li>/<span class="othername">SM</span>/ Fixed Bug#909181 do not sets fields to null</li><li>/<span class="othername">SM</span>/ Fixed Bug #914436 Bug several MySQL TEXT Fields are not correct identified</li><li>/<span class="othername">SS</span>/ Fixed Bug #919395 Memory leak in <tt class="classname">TZExpressionParser</tt>.<tt class="methodname">TokenizeExpression</tt>. Thanks to mocarts.</li><li>/<span class="othername">SS</span>/ Fixed Bug #919401 When dataset is in Edit mode function <tt class="methodname">UpdatesPending</tt> always returns true does matter were changes made or not. Thanks to mocarts.</li><li>/<span class="othername">SS</span>/ Added processing for query parameters with ftGraphic type. Thanks to Pavel Blahovec.</li><li>/<span class="othername">SS</span>/ Added support for SQL specific syntax in Query.SQL and UpdateSQL.</li><li>/<span class="othername">SS</span>/ Added support for SQLite 2.8 database.</li><li>/<span class="othername">SS</span>/ Fixed Bug #924861 Memory leak, when client cannot connect to server</li><li>/<span class="othername">SS</span>/ Added depended compilation for drivers, included into TZConnection drivers list. Now users may select which drivers they want to use to decrease size of their applications. (See /src/Zeos.inc file for details)</li><li>/<span class="othername">SS</span>/ Refactored ZDBC metadata classes.</li><li>/<span class="othername">SS</span>/ Fixed processing of Int64 values in Dataset.Refresh.</li><li>/<span class="othername">SS</span>/ Fixed Bug #933623 'current transaction is aborted, commands ignored until end of transaction block.' error in postgresql when previous statement in transaction fails. Now if autocommit mode is set components automatically rollback failed statements. In manual commit mode developer should explicitely call Connection.Rollback.</li><li>/<span class="othername">SS</span>/ Added GetProtocolNames, GetCatalogNames, GetSchemaNames, GetTableNames, GetStoredProcNames methods into TZConnection component.</li><li>/<span class="othername">SS</span>/ Fixed Bug #824786 TZMetadata shows PostgreSQL 7.4 system tables from 'information_schema' as regular tables.</li><li>/<span class="othername">SS</span>/ Changed type for Dataset.ShowRecordTypes to TUpdateStatusSet.</li><li>/<span class="othername">SS</span>/ Fixed duplicated <tt class="methodname">AfterScroll</tt> event in <tt class="classname">Query</tt>.<tt class="methodname">Locate</tt> and <tt class="classname">Query</tt>.<tt class="methodname">FindRecord</tt> methods.</li><li>/<span class="othername">SS</span>/ Fixed Bug#948940 Random &#8220;<span class="quote">Can not update this query type</span>&#8221; error in PostgreSQL driver. Thanks to Sergio Freue.</li><li>/<span class="othername">SS</span>/ Replaced <span class="property">RequestLive</span> with <span class="property">ReadOnly</span> property in <tt class="classname">TZTable</tt> component to make it more compatible with standard <tt class="classname">TTable</tt>.</li><li>/<span class="othername">SS</span>/ Added <span class="property">InTransaction</span> property in <tt class="classname">TZConnection</tt>component.</li><li>/<span class="othername">SS</span>/ Fixed Bug#957126 Incorrect processing of empty strings in default values in MySQL driver. Thanks to Alex/ghost3k.</li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e1185"></a>9.&nbsp;Changes in Release 6.1</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e1187">9.1. Release 6.1.4 - 21 January 2004</a></span></dt><dt><span class="sect2"><a href="#d4e1254">9.2. Release 6.1.3 - 11 December 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1304">9.3. Release 6.1.2 - 12 November 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1418">9.4. Release 6.1.1 - 28 September 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1604">9.5. Release 6.1.0 - 28 July 2003</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1187"></a>9.1.&nbsp;Release 6.1.4 - 21 January 2004</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed Bug#880459 Access Violation in <tt class="classname">ZSQLProcessor</tt>.<tt class="methodname">Execute</tt> method when <tt class="classname">Connection</tt> is not assigned.</li><li>/<span class="othername">SS</span>/ Fixed Access Violation in MySQL driver when opening a resultset for queries which do not return any data.</li><li>/<span class="othername">SS</span>/ Fixed Bug#881634 Complex select statements return wrong field types.</li><li>/<span class="othername">SS</span>/ Fixed Bug#883027 Wrong comparison for rows with Int64 and Binary Array fields. Thanks to sskacar.</li><li>/<span class="othername">SS</span>/ Fixed Bug#884135 Problem in master-detail links with unsigned int keys.</li><li>/<span class="othername">SS</span>/ Fixed Bug#882150 Incorrect processing empty strings in filter expressions.</li><li>/<span class="othername">SS</span>/ Fixed Bug#887103 BeforeScroll and AfterScroll events are not working with <tt class="methodname">SetRecNo</tt>. Thanks to Alexander Klenin.</li><li>/<span class="othername">SS</span>/ Fixed Bug#886841 Error in processing default values for columns with type enum(y,n) in MySQL driver.</li><li>/<span class="othername">SM</span>/ Fixed Bug#886914 Incorrect updating CHAR not null and empty fields in Interbase/Firebird driver.</li><li>/<span class="othername">SM</span>/ Fixed Bug#886854 Problem with field types for system fields in Firebirb 1.5 RC8 type</li><li>/<span class="othername">SM</span>/ Fixed Bug#882232 Invalid Color property value in ZUpdateSqlEditor.dfm</li><li>/<span class="othername">SM</span>/ Fixed Bug#865299 Interbase 5.5 wrong metadata reading</li><li>/<span class="othername">SS</span>/ Fixed a memory leak in TZSQLProcessor component. Thanks to Martin Fibiger.</li><li>/<span class="othername">SS</span>/ Fixed Bug#894367 Incorrect parsing queries with non-unique field column names.</li><li>/<span class="othername">SS</span>/ Fixed Bug#910804 Wrong processing regular expressions with '*abc' style patterns.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1254"></a>9.2.&nbsp;Release 6.1.3 - 11 December 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed leaving cached statement object in <tt class="classname">TDataset</tt>.<tt class="methodname">ExecSQL</tt> after connection component changed.</li><li>/<span class="othername">SS</span>/ Fixed Bug#862261 Empty blobs sometimes included into Where clause of generated DML statements as &lt;field&gt;=NULL. It caused missed updates.</li><li>/<span class="othername">SS</span>/ Fixed compilation for Kylix 1 compiler.</li><li>/<span class="othername">SS</span>/ Added functions CONCAT, UPPER, LOWER, SUBSTR and STRPOS to filter expressions.</li><li>/<span class="othername">SS</span>/ Fixed Bug#864797 Filter Expressions don't process columns with <tt class="literal">NULL</tt> values correctly.</li><li>/<span class="othername">SM</span>/ Fixed Bug#860196 &amp; #851664 Call Stored Procedures and Firebird 1.5</li><li>/<span class="othername">SM</span>/ Fixed bug #864622  ZQuery return numeric(3,1) fields as IntegerField</li><li>/<span class="othername">SS</span>/ Fixed bug #869609  Wrong behaviour of MySQL AutoIncremented fields</li><li>/<span class="othername">SS</span>/ Fixed error handling in CachedResultSet.DeleteRow method. Thanks for Tobias Giesen.</li><li>/<span class="othername">SM</span>/ Fixed bug #865585 Wrong exception behavior in ExecuteQuery and ExecuteQueryPrepared Thanks for Alex Gilev.</li><li>/<span class="othername">SS</span>/ Fixed processing connection timeout parameter for PostgreSQL.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1304"></a>9.3.&nbsp;Release 6.1.2 - 12 November 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Added <tt class="literal">IS NULL</tt>, <tt class="literal">IS NOT NULL</tt>, <tt class="literal">NOT LIKE</tt> operations to Filter Expression.</li><li>/<span class="othername">SS</span>/ Fixed Bug#842678 AV when removing <tt class="classname">ZUpdateSQL</tt> from <tt class="classname">ZQuery</tt>.</li><li>/<span class="othername">SS</span>/ Added <i class="parameter"><tt>codepage</tt></i> (client codepage) and <i class="parameter"><tt>timeout</tt></i> connection timeout to MySQL and PostgreSQL drivers.</li><li>/<span class="othername">SS</span>/ Added single line comments started with <tt class="literal">--</tt> to MySQL parser.</li><li>/<span class="othername">SS</span>/ Fixed Bug#841425 TZSQLProcessor did not skip empty statements and it cased database errors.</li><li>/<span class="othername">SS</span>/ Fixed Bug#837764 Transaction Isolation Level not set after Commit and Rollback in PostgreSql driver.</li><li>/<span class="othername">SS</span>/ Fixed Bug#840608 Where clause in generated DML statement was incorrect if it included <tt class="literal">NULL</tt> values.</li><li>/<span class="othername">SS</span>/ Fixed generation of UPDATE statements with <span class="property">UpdateMode</span>=<tt class="literal">UpdateChanged</tt>.</li><li>/<span class="othername">SS</span>/ Fixed Bug#840218 <tt class="methodname">Lookup</tt> method returned incorrect result field.</li><li>/<span class="othername">SM</span>/ Fixed Bug#833766 FloatField don't load scale correct</li><li>/<span class="othername">SM</span>/ Added support for interbase 7</li><li>/<span class="othername">SM</span>/ Fixed Bug#845312 Wrong float/double updating in ZDbcInterbase6Utils</li><li>/<span class="othername">SM</span>/ Fixed Bug#847593 Codepage don't set correctly</li><li>/<span class="othername">SM</span>/ Fixed Bug#841559 Triggers and messages</li><li>/<span class="othername">SM</span>/ Fixed Bug#843655 Blob fields don't updates</li><li>/<span class="othername">SM</span>/ Fixed Bug#847594 Exceptions descriptions</li><li>/<span class="othername">SM</span>/ Fixed Bug#844597 AV Error after closing window of ZQuery's <span class="property">Properties</span> properties</li><li>/<span class="othername">SM</span>/ Fixed Bug#841515 C++ Builder 4 Error installing ZeosDBO</li><li>/<span class="othername">SS</span>/ Fixed Bug#849723 Time columns with &#8220;<span class="quote">00:00:00</span>&#8221; values are converted to NULLs in MySQL driver.</li><li>/<span class="othername">SS</span>/ Added doAlwaysDetailResync option to Dataset.Options which turns on/off synchronization between Master and Detail dataset when Master is in Edit or Insert mode.</li><li>/<span class="othername">JF</span>/ Fixed Bug#853690 AutoInc fields in MS SQL</li><li>/<span class="othername">JF</span>/ Fixed Bug#842694 Quoted Fields generated by <tt class="classname">TZUpdateSQL</tt> not accepted by MySQL</li><li>/<span class="othername">JF</span>/ Fixed Bug#841488 Problem with milliseconds in MS SQL dates</li><li>/<span class="othername">SM</span>/ Added support PostgreSql-7.3. Added libpq73.dll and potocol postgresq-7.3</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1418"></a>9.4.&nbsp;Release 6.1.1 - 28 September 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Added support for column default values defined in database. Default values of <tt class="classname">TField</tt> are still unsupported.</li><li>/<span class="othername">SS</span>/ Replaced Borland <span class="type">Variants</span> with custom implementation. It solved many problems with data type convertions and Int64 support in filter expression, master/detail links, locate and many other places.</li><li>/<span class="othername">SS</span>/ Optimized <tt class="methodname">Locate</tt> and <tt class="methodname">Lookup</tt> methods in <tt class="classname">TDataset</tt>. The speed was increased up to 6 times.</li><li>/<span class="othername">SS</span>/ Added <span class="property">UpdateMode</span> and <span class="property">WhereMode</span> properties to <tt class="classname">TDataset</tt>. <span class="property">UpdateMode</span> has two options: <tt class="literal">umUpdateChanged</tt> to post to database only updated fields and <tt class="literal">umUpdateAll</tt> to post all fields.<span class="property">TZWhereMode</span> controls WHERE clause in posted DML statements. <tt class="literal">wmWhereKeyOnly</tt> includes in WHERE only key fields if they exist, <tt class="literal">wmWhereAll</tt> includes all fields.</li><li>/<span class="othername">SS</span>/ Added <span class="property">Options</span> property to <tt class="classname">TDataset</tt>. Now it supports two options <tt class="constant">doOemTranslate</tt> to turn on Ansi to OEM translation in visual controls and <tt class="constant">doCalcDefaults</tt> to turn on/off calculation of column default values defined in database.</li><li>/<span class="othername">SS</span>/ Fixed Bug#816846. PostgreSQL <span class="type">text</span> columns are included now into WHERE clause in autogenerated DML statements. Before they were skipped and it caused problems for tables with <span class="type">text</span> columns where primary key was not defined.</li><li>/<span class="othername">SS</span>/ Fixed Bug#816850 &#8220;<span class="quote">Changing blobs overwrite old values.</span>&#8221;</li><li>/<span class="othername">SS</span>/ Added <span class="property">SortedFields</span> property to <tt class="classname">TDataset</tt>. The format of the <span class="property">SortedFields</span> value should be:<span><b class="command">&lt;Field Name&gt; [ASC | DESC] [,...]</b></span></li><li>/<span class="othername">SS</span>/ Fixed Bug#810249. Added workaround to prevent objects self-destruction in contructors. The bug exist in Delphi 4 and C++ Builder 4 compilers. It decrements reference counter and destroys object if in constructor some interface method is called.</li><li>/<span class="othername">SS</span>/ Excluded ADO driver from Delphi 4 and BCB 4 packages due to lack of support OLE data types in that compilers.</li><li>/<span class="othername">SS</span>/ Fixed Bug#824792. Fixed &#8220;<span class="quote">Interface not supported</span>&#8221; error in <tt class="classname">TZMonitor</tt> in C++ Builder 5 compiler.</li><li>/<span class="othername">SM</span>/ Fixed Bugs #824948 and #824875 &#8220;<span class="quote">Firebird 1.5 - Statement not allowed</span>&#8221;.</li><li>/<span class="othername">SM</span>/ Fixed Bug#815955 &#8220;<span class="quote">Wrong mapping <span class="type">numeric(15)</span> to <tt class="classname">TIntegerField</tt></span>&#8221;</li><li>/<span class="othername">SM</span>/ Fixed Bug#804112 &#8220;<span class="quote">AutoCommit Interbase/Firebird transaction problem</span>&#8221;</li><li>/<span class="othername">SM</span>/ Fixed Bug#789879 &#8220;<span class="quote">Firebird: Float-&gt;Numeric</span>&#8221;</li><li>/<span class="othername">SM</span>/ Fixed Bug#825029 &#8220;<span class="quote">examples - Controls conflict names with Delphi7</span>&#8221;</li><li>/<span class="othername">DD</span>/ Fixed Bug#817612 &#8220;<span class="quote">C++ Builder hpp generation bug</span>&#8221;</li><li>/<span class="othername">SS</span>/ Added support for PostgreSQL domains (user defined types). As a drawback all domain strings types have length 255 characters.</li><li>/<span class="othername">SM</span>/ Fixed Bug#815861 &#8220;<span class="quote">Incorrect parsing of the Version#</span>&#8221; for PostgreSql7.x betas.</li><li>/<span class="othername">SS</span>/ Fixed Bug#831776 &#8220;<span class="quote">TZLoggingEvent is not found</span>&#8221;.</li><li>/<span class="othername">SS</span>/ Fixed Bug#831559 &#8220;<span class="quote">Usage SQL keywords in column names</span>&#8221;.</li><li>/<span class="othername">JF</span>/ Feature Requests#831925. Added several connection parameters to MS SQL: <i class="parameter"><tt>application name</tt></i>, <i class="parameter"><tt>workstation name</tt></i> and few more.</li><li>/<span class="othername">JF</span>/ Fixed Bug#826621. Added reconnection in the case of network problems to MS SQL driver.</li><li>/<span class="othername">JF</span>/ Fixed Bug#817400 &#8220;<span class="quote">Schema support for <tt class="classname">TZTable</tt></span>&#8221;</li><li>/<span class="othername">SS</span>/ Fixed Bug#832467 &#8220;<span class="quote">Filter expression does not process string constants contained single quote symbols inside</span>&#8221;.</li><li>/<span class="othername">SS</span>/ Fixed Bug#830804 &#8220;<span class="quote">Changing dataset fields order in runtime (dragging column in <tt class="classname">DBGrid</tt> for example) causes AV</span>&#8221;.</li><li>/<span class="othername">SS</span>/ Fixed Bug#833197 &#8220;<span class="quote">Refresh problem with filtered data</span>&#8221;.</li><li>/<span class="othername">JF</span>/ Fixed issues related to ADO in Delphi 4 and C++ Builder 4 compilers.</li><li>/<span class="othername">SS</span>/ Added <tt class="literal">STRICT_DLL_LOADING</tt> definition into <tt class="filename">/src/Zeos.inc</tt> to prevent loading of <tt class="filename">libmysql.dll</tt> and <tt class="filename">libpq.dll</tt> libraries by default. If was done because of constant user problems with unsupported dlls. To enforce loading default libraries you should comment the definition and recompile the components.</li><li>/<span class="othername">SS</span>/ Added optimization for switching transaction modes in MySQL driver.</li><li>/<span class="othername">JF</span>/ Added support of SQLHourGlass cursor in the component.</li><li><p>/<span class="othername">SS</span>/ Fixed Bug#834798 &#8220;<span class="quote">Locate with [loCaseInsensitive] parameters does not work</span>&#8221;.</p></li><li><p>/<span class="othername">SS</span>/ Fixed Bug#839540 Logical operations don't work properly in filter expression.</p></li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1604"></a>9.5.&nbsp;Release 6.1.0 - 28 July 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Rewritten SQL parsers, removed Parse package from the project.</li><li>/<span class="othername">SS</span>/ Modified <tt class="classname">TZSQLProcessor</tt> component.</li><li>/<span class="othername">JF</span>/ ADO driver is added.</li><li>/<span class="othername">JF</span>/ Modified <tt class="classname">TZBlobStream</tt> to support notification about change.</li><li>/<span class="othername">SS</span>/ Code has been optimized.</li><li>/<span class="othername">SS</span>/ Finished source code review.</li><li>/<span class="othername">SS</span>/ Added parameters to ZDBC statements.</li><li>/<span class="othername">SS</span>/ Added multiple statements property to <tt class="classname">TZUpdateSQL</tt>.</li><li>/<span class="othername">SS</span>/ Added <tt class="classname">TZSQLMonitor</tt> component.</li><li>/<span class="othername">SS</span>/ Added filter expressions</li><li>/<span class="othername">JF</span>/ Stored procedure support for mssql dblib interface, works for sybase also</li><li>/<span class="othername">SS</span>/ Added <span class="property">DataSource</span> property in <tt class="classname">TDataset</tt> to support master-detail links.</li><li>/<span class="othername">SS</span>/ Added <span class="property">MasterSource</span>, <span class="property">MasterFields</span> and <span class="property">IndexFieldNames</span> to support master-detail links with client-side filtering</li><li>/<span class="othername">SS</span>/ Added support for MySQL autoincremented fields</li><li>/<span class="othername">JF</span>/ Added support for Sybase and MS SQL identity fields</li><li>/<span class="othername">JF</span>/ Added support for exiting without error messages in case of broken connection</li><li>/<span class="othername">JF</span>/ Added some new metadata columns to getcolumns to support calculated fields</li><li>/<span class="othername">JF</span>/ Autoincremented field support for mssql, sybase and ado added  to return the generated value.</li><li>/<span class="othername">JF</span>/ Added workaround for procedure parameter type query for sybase. It works only for ASE12.5 or above</li><li>/<span class="othername">JF</span>/ Added workaround for sybase structure 'AND NULL IS NULL' resulted in error: Invalid operator for datatype op: is null type: VOID TYPE.</li><li>/<span class="othername">SS</span>/ Added <tt class="classname">TZTable</tt> component.</li><li>/<span class="othername">SS</span>/ Added <tt class="classname">TZSQLMetadata</tt> component.</li><li>/<span class="othername">SS</span>/ Added caching for database metadata</li><li>/<span class="othername">SM</span>/ Fixed Bug#804112 AutoCommit Interbase/Firebird transaction problem.</li><li>/<span class="othername">SM</span>/ Fixed Bug#795832 Exception handling in Interbase statement</li><li>/<span class="othername">SM</span>/ Added Plain API for DB2 </li></ul></div></div></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="d4e1722"></a>10.&nbsp;Changes in Release 6.0</h2></div></div></div><div class="toc"><dl><dt><span class="sect2"><a href="#d4e1724">10.1. Release 6.0.12 Patch#3 - 28 September 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1753">10.2. Release 6.0.12 Patch #2 - 28 September 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1785">10.3. Release 6.0.12 Patch #1 - 28 September 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1810">10.4. Release 6.0.12 - 18 July 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1843">10.5. Release 6.0.11 - 08 July 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1900">10.6. Release 6.0.10 - 13 June 2003</a></span></dt><dt><span class="sect2"><a href="#d4e1981">10.7. Release 6.0.9 - 18 May 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2087">10.8. Release 6.0.8 - 15 April 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2102">10.9. Release 6.0.7 - 13 April 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2149">10.10. Release 6.0.6 - 30 March 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2196">10.11. Release 6.0.5 - 18 March 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2251">10.12. Release 6.0.4 - 24 February 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2286">10.13. Release 6.0.3 - 17 February 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2305">10.14. Release 6.0.2 - 9 February 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2336">10.15. Release 6.0.1 - 2 February 2003</a></span></dt><dt><span class="sect2"><a href="#d4e2363">10.16. Release 6.0.0 - 25 January 2003</a></span></dt></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1724"></a>10.1.&nbsp;Release 6.0.12 Patch#3 - 28 September 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed Bug#817607 Fail refreshing Query when field names contain spaces.</li><li>/<span class="othername">SS</span>/ Fixed AV when connection is destroyed before linked datasets (Thanks to Ask).</li><li>/<span class="othername">SS</span>/ Fixed Bug#826624 Incorrect converting for <span class="type">Int64</span> Params (Thanks to Dmitry Krylov)</li><li>/<span class="othername">SS</span>/ Fixed Bug#816925 Wrong mapping of <span class="type">Decimal</span> and <span class="type">Numeric</span> fields in MySQL</li><li>/<span class="othername">SS</span>/ Fixed Bug#826886 AV in <tt class="classname">TDataset</tt>.<tt class="methodname">ExecSQL</tt> after disconnecting <tt class="classname">TZConnection</tt>.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1753"></a>10.2.&nbsp;Release 6.0.12 Patch #2 - 28 September 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/  Fixed Bug#803616 Fail posting inserted and then updated records in cached updates mode.</li><li>/<span class="othername">SS</span>/ Fixed Bug#804323 Calculated fields in read only datasets.</li><li>/<span class="othername">SS</span>/ Fixed Bug#804640 Calculated fields of type <tt class="classname">TCurrencyField</tt> returns always 0.00.</li><li>/<span class="othername">SS</span>/ Fixed Bug#802548 Error &#8220;<span class="quote">List Index out of Bounds (-1)</span>&#8221; in <tt class="methodname">Refresh</tt> method.</li><li>/<span class="othername">SS</span>/ Added missed events to <tt class="classname">TZSQLProcessor</tt> (Thanks to Josef Fuchs).</li><li>/<span class="othername">SS</span>/ Added support for <span class="type">LONGTEXT</span> field type in MySQL driver.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1785"></a>10.3.&nbsp;Release 6.0.12 Patch #1 - 28 September 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed Bug#793351 access violation when assigning a field value</li><li>/<span class="othername">JF</span>/ Fixed Bug#791101 Transaction not working with MS SQL</li><li>/<span class="othername">JF</span>/ Fixed Bug#791096 &#8220;<span class="quote">List index out of bounds</span>&#8221; problem when canceling a newly added row.</li><li>/<span class="othername">SS</span>/ Fixed Bug#798336 Not passing large objects to Postgres DB.</li><li>/<span class="othername">SS</span>/ Fixed Bug#799863 Cannot see <span class="type">YEAR</span> type in Delphi.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1810"></a>10.4.&nbsp;Release 6.0.12 - 18 July 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed Bug#773400. In plain interface for MySQL 4.0 the name of shared library was 'libmysqld.so' instead of 'libmysqlclient.so'</li><li>/<span class="othername">SS</span>/ Fixed Bug#772926 with incorrect <tt class="classname">TZDataset</tt>.<tt class="methodname">Cancel</tt> behaviour.</li><li>/<span class="othername">SS</span>/ Fixed out of range exception in <tt class="classname">TZDataset</tt>.<tt class="methodname">Last</tt> method.</li><li>/<span class="othername">SS</span>/ Fixed problem with incorrect order of dataset input parameters.</li><li>/<span class="othername">JF</span>/ <tt class="methodname">Refresh</tt> problem solved                                                                         </li><li>/<span class="othername">SM</span>/ Fixed Bug#768163 with <span class="type">unsigned int</span> fields in MySQL</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1843"></a>10.5.&nbsp;Release 6.0.11 - 08 July 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Eliminated all overrided methods in API, fixed support for C++ Builder 4,5,6 compilers.</li><li>/<span class="othername">SS</span>/ Added optimization to <tt class="classname">TZAbstractDODataset</tt>.<tt class="methodname">ExecSQL</tt> and <tt class="classname">TZEmulatedPreparedStatement</tt>. Now executing prepared statements without parameters about 10 times faster, with parameters - 25% faster.</li><li>/<span class="othername">SS</span>/ Fixed <tt class="classname">TZConnection</tt>.<tt class="methodname">AutoCommit</tt> and <tt class="classname">TZConnection</tt>.<tt class="methodname">TransactIsolationLevel</tt> property behavior.</li><li>/<span class="othername">JF</span>/ <span class="property">LoginPrompt</span> support added. Delphi4 and Delphi5 needs some extra work.</li><li>/<span class="othername">SM</span>/ Fixed Bug #759184 empty <span class="type">string</span> field return by SQL query with concatination fields</li><li>/<span class="othername">SM</span>/ Fixed Bug #707337 emty values for virtual columns</li><li>/<span class="othername">SS</span>/ Added support for quoted parameters in <tt class="classname">TZQuery</tt> and <tt class="classname">TZUpdateSQL</tt>.</li><li>/<span class="othername">SS</span>/ Fixed Bug#771217 caused by incorrect processing MySQL table names with special characters like 'my-table'</li><li>/<span class="othername">SS</span>/ Fixed Bug#773022: wrong <tt class="classname">TQuery</tt>.<tt class="methodname">RecordCount</tt> after deletes</li><li>/<span class="othername">SS</span>/ Changed processing of &#8220;<span class="quote">0000-00-00</span>&#8221; dates in MySQL. Now they are treated as NULLs simular to ODBC drivers.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1900"></a>10.6.&nbsp;Release 6.0.10 - 13 June 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed Bug#752603 in <tt class="classname">TZDataset</tt>.<tt class="methodname">GetFieldData</tt> method which set <span class="property">Field</span>.<span class="property">IsNull</span> = <tt class="constant">True</tt> all the time.</li><li>/<span class="othername">SS</span>/ Fixed Bug#753397: in bounds checking in <tt class="classname">TZCollection</tt>.<tt class="methodname">SetCapacity</tt> which followed to Access Violation in Delphi 4.</li><li>/<span class="othername">SM</span>/ Finished scripts build &amp; test environment</li><li>/<span class="othername">SM</span>/ Added Kylix2 support</li><li>/<span class="othername">SM</span>/ Fixed test framework and tests for Kylix/Linux support</li><li>/<span class="othername">SS</span>/ Fixed remaining issues with Delphi 4 and 5 compilers. The testing libraries for Delphi 4,5 are work as expected.</li><li>/<span class="othername">SM</span>/ Fixed Interbase <span class="type">datetime</span> parameters </li><li>/<span class="othername">JF</span>/ Fixed <span class="type">varbinary</span> datatype. It will be a <span class="type">blob</span> field.</li><li>/<span class="othername">SS</span>/ Fixed bug#750912: Interbase Lookup fields.</li><li>/<span class="othername">SM</span>/ Fixed bug#754009: Cast error while fetching</li><li>/<span class="othername">SM</span>/ Added Firebird 1.5 support</li><li>/<span class="othername">SM</span>/ Fixed leak memory in <tt class="methodname">GetBlob</tt> method for MySQL &amp; PostgreSql</li><li>/<span class="othername">SS</span>/ Added support for MySQL 4.0 native client</li><li>/<span class="othername">SS</span>/ Fixed Bug#761300 Memory leak in <tt class="classname">TZReadOnlyQuery</tt></li><li>/<span class="othername">JF</span>/ The <tt class="classname">TDataset's</tt> default <tt class="methodname">Translate</tt> method is overriden in order to provide basic OEM/ANSI translation, but later it should be database specific.</li><li>/<span class="othername">JF</span>/ The previous one is removed because it caused more problems than it solved.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e1981"></a>10.7.&nbsp;Release 6.0.9 - 18 May 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed bugs in <tt class="classname">TZCollection</tt> class and <tt class="classname">TZAbstractObject</tt>.<span class="property">Equals</span> (Thanks for Karl Waclawek).</li><li>/<span class="othername">SS</span>/ Fixed Bug#733209 with incorrect decimal separator in <tt class="classname">TZToken</tt>.<tt class="methodname">GetString</tt>. (Thanks to Leonardo Quaggiotto).</li><li>/<span class="othername">SS</span>/ Added support for MySQL <span class="type">boolean</span> type  /<span class="type">enum('Y','N')</span>/</li><li>/<span class="othername">SS</span>/ Fixed Bug#726788 with mixed identificators in MySQL (Thanks to Maarten Bremer).</li><li>/<span class="othername">SS</span>/ Fixed bug in numeric tokenizer. Combinations of symbols '.e' and '.E' were always processed as numbers. For example: a.eq_id was tokenized as 'a' '.e' 'q_id' instead 'a' '.' 'eq_id'</li><li>/<span class="othername">SM</span>/ Added support Interbase 5, 6.X, Firebird 1.X</li><li>/<span class="othername">SM</span>/ GetImportedKeys, GetExportedKeys, GetIndexInfo done for Interbase Database Metadata </li><li>/<span class="othername">SS</span>/ Fixed Bug#740144 with search by Null fields in TZQuery.Locate</li><li>/<span class="othername">SS</span>/ Fixed Bug#740899. Expressions Field=NULL were not properly converted into Field IS NULL in where clauses.</li><li>/<span class="othername">SS</span>/ Completely rewritten SQL parsers because of peformance reasons.</li><li>/<span class="othername">SS</span>/ Fixed Bug#739514 with national string convertion for postgresql.</li><li>/<span class="othername">JF</span>/ Fixed Bug#728955 multiple results returned</li><li>/<span class="othername">JF</span>/ Fixed datatype handling in metadata getColumn to match the modifications via Seroukhov</li><li>/<span class="othername">SS</span>/ Fixed Bug#746225 with updating empty Memo fields.</li><li>/<span class="othername">SM</span>/ Fixed Interbase metadata GetPrimaryKeys, GetProcedures, GetProcedureColumns</li><li>/<span class="othername">SS</span>/ Fixed Bug#739448 with duplicated column names. Now if query returns columns: 'fld','fld','fld', result set will contain display labels 'fld','fld_1','fld_2'</li><li>/<span class="othername">SS</span>/ Fixed Bug#733236 with time fields convertion in TDataset.Locate.</li><li>/<span class="othername">SS</span>/ Optimized code, added DISABLE_CHECKING compiler definition into Zeos.inc file. According performance tests this definition gives about 10% speedup. </li><li>/<span class="othername">SM</span>/ Fixed problem with WasNull in fetch processing in InterbaseResultSet.</li><li>/<span class="othername">SM</span>/ Added example - controls.</li><li>/<span class="othername">SS</span>/ Fixed Bug#725053 with empty lookup fields</li><li>/<span class="othername">SS</span>/ Fixed Bug#739707: Variant convertion error in IZPreparedStatement.SetBlob</li><li>/<span class="othername">JF</span>/ Fixed Numeric scale errors in sybase, was caused by usage of float type instead of double</li><li>/<span class="othername">JF</span>/ Added a workaround for a bug? in mssql dblib interface. All text like '\'#13 was replaced to just #13. I just double the backslash in this case.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2087"></a>10.8.&nbsp;Release 6.0.8 - 15 April 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed Bug#722651 AV in TZDbcMySQLResultSet.GetTimestamp</li><li>/<span class="othername">SS</span>/ Added caching for Server version and data types in PostgreSQL connection.</li><li>/<span class="othername">RFC</span>/ Added packages for Kylix 1 and Kylix 3.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2102"></a>10.9.&nbsp;Release 6.0.7 - 13 April 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed Bug#706278 related to performance problems in MySQL</li><li>/<span class="othername">SS</span>/ Fixed Bug#715099 in TZAbstractRODataset.FindNext</li><li>/<span class="othername">SS</span>/ Added select parser for PostgreSQL</li><li>/<span class="othername">SS</span>/ Added generic support for case sensitive catalogs, tables and columns</li><li>/<span class="othername">SS</span>/ Fixed Bug#720785 in CachedResultSet error handling.</li><li>/<span class="othername">SS</span>/ Fixed Bug#720787 in SQL parser performance</li><li>/<span class="othername">SS</span>/ Added GetPChar/SetPChar methods to prevent multiple strings convertion</li><li>/<span class="othername">SS</span>/ Added performance optimization into PreparedStatement and GenericCacheResolver.</li><li>/<span class="othername">SS</span>/ Added packages for Kylix 1</li><li>/<span class="othername">JF</span>/ Fixed MS SQL and Sybase quotation problems</li><li>/<span class="othername">JF</span>/ Fixed FindColumn to properly support case sensitive and case insensitive columns</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2149"></a>10.10.&nbsp;Release 6.0.6 - 30 March 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed AV in Dataset.GetFieldData method.</li><li>/<span class="othername">SS</span>/ Set default port for MySQL</li><li>/<span class="othername">SS</span>/ Fixed Bug#707339 caused by incorrect mapping for boolean type.</li><li>/<span class="othername">SS</span>/ Fixed Bug#707337 in PostgreSQL calculated columns.</li><li>/<span class="othername">SS</span>/ Fixed Bug#707364 AV in TZSQLProcessor when exception happens</li><li>/<span class="othername">JF</span>/ Optimized blob handling internally</li><li>/<span class="othername">SS</span>/ Added SetCachedUpdates method to permit changes after query open.</li><li>/<span class="othername">SS</span>/ Added BeforeRefresh and AfterRefresh events in Query components.</li><li>/<span class="othername">SS</span>/ Added useresult connection parameter for MySQL</li><li>/<span class="othername">SS</span>/ Made several fixes for PostgreSQL blobs.</li><li>/<span class="othername">DD</span>/ Added packages for C++ Builder 6.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2196"></a>10.11.&nbsp;Release 6.0.5 - 18 March 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Modified transaction support for MySQL (Thanks to Pavel Shibanov).</li><li>/<span class="othername">SS</span>/ Added GetSupportedProtocols method to IZDriver</li><li>/<span class="othername">SS</span>/ Added packages for C++ Builder 4,5</li><li>/<span class="othername">SS</span>/ Fixed Access Violation in MySQL.GetColumns</li><li>/<span class="othername">SS</span>/ Fixed behavior of TZDataset.Last method.</li><li>/<span class="othername">SM</span>/ Added scripts for build &amp; test environment, restructured  project packages</li><li>/<span class="othername">SS</span>/ Added a property editor for ZConnection.Protocol</li><li>/<span class="othername">SS</span>/ Added 'oidasblob' connection parameter to PostgreSQL when oidasblob=false (default) Oid fields are treated as integer and bytea fields as Blobs. When oidasblob=true Oid fields represent Blobs and bytea fields are ByteArray[256].</li><li>/<span class="othername">SS</span>/ Added classes for Bug Report Test Cases</li><li>/<span class="othername">SS</span>/ Fixed bug#702368  "... wrong size ..." when column in bytea datatype.</li><li>/<span class="othername">SM</span>/ Fixed PostgreSQLToSQLType for PostgreSQL timestamptz datatype</li><li>/<span class="othername">SS</span>/ Fixed ArrayOutOfBounds exception in TZReadOnlyDataSet.Reread</li><li>/<span class="othername">SS</span>/ Fixed refreshing FieldDefs after SQL query update.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2251"></a>10.12.&nbsp;Release 6.0.4 - 24 February 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Added a reference implementation for Plain API multiversion support. It includes TZNativeLibraryLoader, IZPlainDriver, IZMySQLPlainDriver and other classes and interfaces.</li><li>/<span class="othername">SS</span>/ Fixed SetTransactionIsolation for MySQL and PostgreSQL.</li><li>/<span class="othername">SS</span>/ Fixed MaxRows in CachedResultSet, MySQLResultSet and PostgreSQLResultSet.</li><li>/<span class="othername">JF</span>/ Modified SetTransactionIsolation for MsSql and Sybase</li><li>/<span class="othername">SS</span>/ Renamed ZUpdateSql into ZSqlUpdate and ZBlobStream into ZStreamBlob to prevent conflicts with an older zeos version.</li><li>/<span class="othername">SS</span>/ Modified PostgreSQL DBC API to use plain drivers.</li><li>/<span class="othername">SS</span>/ Added ErrorCode to EZSQLException</li><li>/<span class="othername">SS</span>/ Added ZSqlScript component</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2286"></a>10.13.&nbsp;Release 6.0.3 - 17 February 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">JF</span>/ Fixed problem with queries using parameters with the same name</li><li>/<span class="othername">SS</span>/ Implemented persistence for SQL Params in TZDataset and TZUpdateSQL.</li><li>/<span class="othername">SS</span>/ Added DesignTime test application.</li><li>/<span class="othername">SS</span>/ Implemented restoring SQL Params values after SQL query updates.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2305"></a>10.14.&nbsp;Release 6.0.2 - 9 February 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Updated project examples</li><li>/<span class="othername">SS</span>/ Implemented reading FieldDefs on closed dataset. This feature is required to work with dataset columns in visual designer.</li><li>/<span class="othername">SS</span>/ Implemented writing PostgreSql blobs.</li><li>/<span class="othername">SS</span>/ Fixed three interface cycle references in Parse API which followed to massive memory leaks (Many thanks to Vincent Mahon, the author of MemCheck utility!)</li><li>/<span class="othername">SM</span>/ Added testing framework classes</li><li>/<span class="othername">SS</span>/ Fixed three interface cycle references in DBC API. </li><li>/<span class="othername">SS</span>/ Changed AbstractDatabaseMetadata and MySQLDatabaseMetadata classes to reduce repeatable code.</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2336"></a>10.15.&nbsp;Release 6.0.1 - 2 February 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>/<span class="othername">SS</span>/ Fixed date, time and datetime columns handling</li><li>/<span class="othername">SS</span>/ Implemented support primary keys in autogenerated where clauses</li><li>/<span class="othername">SS</span>/ Fixed problems with delete and insert in cached updates mode</li><li>/<span class="othername">SS</span>/ Added synchronization between TZConnection and TZDataset components</li><li>/<span class="othername">SM</span>/ Added icons and registration for non-visual components</li><li>/<span class="othername">JF</span>/ Made numerious changes in MS SQL connectivity API</li></ul></div></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a id="d4e2363"></a>10.16.&nbsp;Release 6.0.0 - 25 January 2003</h3></div></div></div><div class="itemizedlist"><ul type="disc" compact><li>Released the first alpha version with support for MySQL, PostgreSQL, Interbase 6+ and MS SQL.</li></ul></div></div></div></div><div xmlns="" id="customfooter">
(c) 1999 - 2006 The Zeos Development Group
</div></body></html>